package com.dcits.electronic_account.mapper;

import com.dcits.electronic_account.bean.BankAccount;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.math.BigDecimal;

/**
 * @Author: 周智鑫
 * @Date： 2022/6/26
 */
@Mapper
public interface VirtualBanlanceMapper {
    /**
     * 查询虚拟账户余额
     * @param id 账户id
     * @return 虚拟账户余额
     */
    @Select("select balance from virtual_account where user_id=#{id}")
    BigDecimal virtualAccountBalance(int id);
}
